Hero image

Captain scarlet's Shop

Average Rating4.04
(based on 68 reviews)

Excel workbooks. and a couple of full lessons

18Uploads

84k+Views

47k+Downloads

Excel workbooks. and a couple of full lessons
Class Assessment/Test Analyser Spreadsheet
captain scarletcaptain scarlet

Class Assessment/Test Analyser Spreadsheet

(4)
Excel spreadsheet which can be used to analyse test results for a class so you can see where to target your revision? Graph shows poorly answered questions. There is a set of example data already in the data set page. This is help, so that you can see how to fill in. To remove the data, highlight and then CLEAR CONTENTS
House point, Merit accumulator
captain scarletcaptain scarlet

House point, Merit accumulator

(7)
Ever tried to keep track of house points? This sheet is user defined, so if you award prizes for merit points, an easy to see status grid shows how many points are still required for particular prize. User defined, up to 7 prizes can be awarded. Also shows pupils where they stand in the class. Graph shows same details. There is also a handy help page if you get stuck. Can also show pupils with low merits. Can also show pupils with compliments for good work, as well as concern slips. Divided in half termly sections, so setting half term targets is easy. Grid accompanies this to show pupils who have attained the half term target. HAVE FUN
Revised Merit/House point accumulator (version XL5)
captain scarletcaptain scarlet

Revised Merit/House point accumulator (version XL5)

(5)
Sorry people, section for concerns and compliments, not working correctly in the revised version of this sheet. THIS HAS BEEN RESOLVED IN THIS SHEET. Any data already typed into your revised version can but cut and pasted into this one. Keep track of all those house points earned by your form/house/year. Easy to use, set out in 1/2 term sections. room for prizes for certain amount of points. THIS WILL SAVE YOU OODLES OF TIME. ROOM FOR 37 PUPILS ON THE SHEET. on the first sheet, scroll down to row 40+, you will need to fill in a little data there. There are a couple of useful help sheets contained as well.
Random letter generator
captain scarletcaptain scarlet

Random letter generator

(0)
Generate a series of random letters 14. Guaranteed at least 2 vowels each time. Can generate up to 32 rounds. Give pupils the challenge, as it nominates certain criteria. Start with, either Red, Blue or black letters. Sometimes an ‘Any’ letter option will be nominated. Sometimes the word has to start with a capital letter. You can allow ‘proper names, as it generates both Upper case and Lower case letters. All totally random. No 2 turns will give the same letters. Divide pupils into teams and score points for the length of words made. Generates 14 letters. Within the sheet are 2 help sheets
Assessment made EASY
captain scarletcaptain scarlet

Assessment made EASY

(4)
Easy to use. A guide and fully working sheet. Use defined up to 138 tests assignment or homework, or a combination of all 3. Up to 250 pupils can be added to the sheet. colour code for easy reading. readout for pupils on target or below or above. Space for awards of extra merits. You only have to input the minimal of data. Easy to follow, saves bucket loads of time once the initial data has been input. PLEASE NOTE: There is also available in my resources a guide to show you how to fill in this workbook,
Revised Money collection sheet
captain scarletcaptain scarlet

Revised Money collection sheet

(0)
Excel sheet to log all payments for trips out. Easy to use. Please note, some of the sheets are password protected. You do not need the password, it is there to protect the calculations behind the sheet. Up to 190 spaces (pupils) Sheet shows how much paid by each pupil and how much is still outstanding. There is also a sort sheet at the back. Will tell you when the trip has been paid in full. Payment made by pupils an be entered in any order, up to 26 payment increments allowed for.
Assessment made EASY  GUIDE
captain scarletcaptain scarlet

Assessment made EASY GUIDE

(1)
GUIDE TO ASSESSMENT MADE EASY This is only a guide, some of the pages are disabled. It does show you though what is obtained from the Assessment made easy spreadsheet. You can then decide if it would be worth downloading it, Especially as you can see the outcome without wasting any of your time .